package com.ysd.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

	public  class DBManager {
		private final static String DRIVER = "com.mysql.jdbc.Driver";
		private final static String URL = "jdbc:mysql://localhost:3306/haoduoyu";
		private final static String USER = "root";
		private final static String PWD = "admin";
		
		public static Connection getConnection() {
			try {
				Class.forName(DRIVER);
				return DriverManager.getConnection(URL,USER,PWD);
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			} catch (Exception e) {
				e.printStackTrace();
			}
			return null;
		}
		
		public static int executeUpdate(String sql) {
			Connection conn = null;
			Statement st = null;
			try {
				conn = getConnection();
				st = conn.createStatement();
				return st.executeUpdate(sql);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				return -1;
			}finally {
				closeAll(conn,st,null);
			}
		} 
		
		public static void closeAll(Connection conn,Statement st,ResultSet rs) {
			try {
				if (rs != null) {
					rs.close();
				}
				if(st != null) {
					st.close();
				}
				if (conn != null) {
					conn.close();
				}
			} catch (Exception e) {
				// TODO: handle exception
				e.printStackTrace();
			}
		}
		
	}

